<?php 
	error_reporting(E_ERROR);
	error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
	require_once "dbconnect.php";
	
	$city='';
	$country='';
	$code='';
	$zipcode='';
	
	$sql = mysql_query("SELECT
					city.cityname,
					country.countryname,
					country.countrycode,
					city.zipcode
					FROM
					city
					INNER JOIN country ON country.countryid = city.countryid");	
					
		$city= $result['cityname'];
		$country = $result['countryname'];
		$code = $result['countrycode'];
		$zipcode = $result['zipcode'];
?>
